DBMS Interview Questions and Answers
Test your skills through the online practice test: DBMS Quiz Online Practice Test
Related differences
Ques 46. What is 2NF?
A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.
Is it helpful?
Add Comment
View Comments
Ques 47. What is 3NF?
A relation schema R is in 3NF if it is in 2NF and for every FD X A either of the following is true
1. X is a Super-key of R.
2. A is a prime attribute of R.
In other words, if every non prime attribute is non-transitively dependent on primary key.
Is it helpful?
Add Comment
View Comments
Ques 48. What is BCNF (Boyce-Codd Normal Form)?
A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X A, X must be a candidate key.
Is it helpful?
Add Comment
View Comments
Ques 49. What is 4NF?
A relation schema R is said to be in 4NF if for every Multivalued dependency X Y that holds over R, one of following is true.
1.) X is subset or equal to (or) XY = R.
2.) X is a super key.
Is it helpful?
Add Comment
View Comments
Ques 50. What is 5NF?
A Relation schema R is said to be 5NF if for every join dependency {R1, R2, ..., Rn} that holds R, one the following is true
1) Ri = R for some i.
2) The join dependency is implied by the set of FD, over R in which the left side is key of R.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users:
- What is database or database management systems (DBMS)?
- What is SQL?
- What's the difference between file and database? Can files qualify as a database?
- What’s difference between DBMS and RDBMS?
- How many types of relationship exist in database designing?